Quiz in Excel
問題一覧
1
The error message which addresses a cell that does not exist such as a deleted cell.
#REF?
2
It is a spreadsheet program designed to create, organize, and analyze data.
Excel
3
Shortcut keys to display the current system time of the computer.
CTRL + SHIFT+ ;
4
The error message uses a cell name that you have not defined or misspelled.
#NAME?
5
It is the file in which you work and stores your data.
Workbook
6
Shortcut key to move the cursor or insertion point to the next line.
Alt Enter
7
The symbol is used to convert the number to text.
Single Quote
8
It consist of cells that re organized into columns and rows and a primary document that you see in Excel to store and work with data.
Worksheet
9
It is a group of incremental number, dates, or time periods.
Series
10
This function displays the current system date and time of the computer.
=Now()
11
In the series option, this specifies the increment between numbers in the series
Step value
12
In each number in a series is calculated by multiplying the preceding number by the step value
Growth Series
13
In the series option, specifies the highest value that can be entered in the selected range.
Stop Value
14
This series feature creates a series automatically for several types of data
Auto Fill
15
True or False? All cells in the worksheet by default are locked.
True
16
Function key to edit a label in a cell
F2
17
These are text entries in excel consisting of any combination of letters or numbers
Labels
18
Total columns in excel
16, 384
19
An error in excel that the program can't display the formula in the cell
######
20
Displays the content(value or formula) of the active cell
Formula Bar
Shortcut Keys
Shortcut Keys
Jhen Rose Barroga · 27問 · 2年前Shortcut Keys
Shortcut Keys
27問 • 2年前Integrated Hardware
Integrated Hardware
Jhen Rose Barroga · 25問 · 1年前Integrated Hardware
Integrated Hardware
25問 • 1年前Excel and PPT
Excel and PPT
Jhen Rose Barroga · 87問 · 1年前Excel and PPT
Excel and PPT
87問 • 1年前Quiz 1
Quiz 1
Jhen Rose Barroga · 22問 · 1年前Quiz 1
Quiz 1
22問 • 1年前Quiz #1
Quiz #1
Jhen Rose Barroga · 39問 · 1年前Quiz #1
Quiz #1
39問 • 1年前Access
Access
Jhen Rose Barroga · 17問 · 1年前Access
Access
17問 • 1年前Photoshop
Photoshop
Jhen Rose Barroga · 100問 · 1年前Photoshop
Photoshop
100問 • 1年前Excel
Excel
Jhen Rose Barroga · 55問 · 1年前Excel
Excel
55問 • 1年前Excel and PPT
Excel and PPT
Jhen Rose Barroga · 87問 · 1年前Excel and PPT
Excel and PPT
87問 • 1年前Photoshop 2
Photoshop 2
Jhen Rose Barroga · 7問 · 1年前Photoshop 2
Photoshop 2
7問 • 1年前問題一覧
1
The error message which addresses a cell that does not exist such as a deleted cell.
#REF?
2
It is a spreadsheet program designed to create, organize, and analyze data.
Excel
3
Shortcut keys to display the current system time of the computer.
CTRL + SHIFT+ ;
4
The error message uses a cell name that you have not defined or misspelled.
#NAME?
5
It is the file in which you work and stores your data.
Workbook
6
Shortcut key to move the cursor or insertion point to the next line.
Alt Enter
7
The symbol is used to convert the number to text.
Single Quote
8
It consist of cells that re organized into columns and rows and a primary document that you see in Excel to store and work with data.
Worksheet
9
It is a group of incremental number, dates, or time periods.
Series
10
This function displays the current system date and time of the computer.
=Now()
11
In the series option, this specifies the increment between numbers in the series
Step value
12
In each number in a series is calculated by multiplying the preceding number by the step value
Growth Series
13
In the series option, specifies the highest value that can be entered in the selected range.
Stop Value
14
This series feature creates a series automatically for several types of data
Auto Fill
15
True or False? All cells in the worksheet by default are locked.
True
16
Function key to edit a label in a cell
F2
17
These are text entries in excel consisting of any combination of letters or numbers
Labels
18
Total columns in excel
16, 384
19
An error in excel that the program can't display the formula in the cell
######
20
Displays the content(value or formula) of the active cell
Formula Bar