Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Give this quiz to my class
Q 1/35
Score 0
A formula that has at least two different mathematical operators is called what?
20
simple formula
function
complex formula
complex function
Q 2/35
Score 0
Multiple worksheets within one file are collectively called what?
20
excel
PDF
workbook
text
35 questions
Q.
A formula that has at least two different mathematical operators is called what?
1
20 sec
Q.
Multiple worksheets within one file are collectively called what?
2
20 sec
Q.
A formula that has just one mathematical operation is called what?
3
20 sec
Q.
A single sheet within a workbook that contains data
4
20 sec
Q.
Cells labeled with numbers going down a worksheet are called what?
5
20 sec
Q.
Cells labeled with letters that go across a worksheet are called what?
6
20 sec
Q.
The location or name of the cell is called it's what? Example A2
7
20 sec
Q.
This action allows you to temporarily hide data.
8
20 sec
Q.
A reference that used a particular cell over and over again as opposed to changing the cells relative to the position of the formula is what type of reference?
9
20 sec
Q.
Organizing data is called what?
10
20 sec
Q.
A group of cells represented by a colon : is called what? Ex: A5:A8
11
20 sec
Q.
Changing the formula based on a cell's relative position within the worksheet when copying a formula across cells is what type of reference?
12
20 sec
Q.
Miniature charts inserted within just one cell are called what?
13
20 sec
Q.
A predefined formula used to calculate data where you don't need to use any mathematical operator signs.
14
20 sec
Q.
Cells can only contain numbers
15
20 sec
Q.
To select a group of cells, my cursor should look like a thin, back plus sign.
16
20 sec
Q.
If #### appear in your cell after inserting a formula, your formula is incorrect.
17
20 sec
Q.
Grouping worksheets allows a change on one sheet to appear on the other sheet.
18
20 sec
Q.
Autosum only adds numbers together
19
20 sec
Q.
I can only sort data alphabetically or numerically.
20
20 sec
Q.
I can only sort by up to two criteria at a time
21
20 sec
Q.
What formatting does not affect the column width?
22
20 sec
Q.
To rename a worksheet or copy a worksheet, I should
23
20 sec
Q.
To edit a formula I can
24
20 sec
Q.
A benefit to using a function instead of a formula would be
25
20 sec
Q.
When should I use an absolute reference?
26
20 sec
Q.
What is used to separate ranges and individual cells when creating functions?
27
20 sec
Q.
To insert a function, I can
28
20 sec
Q.
To access the freeze panes options, I look under which tab?
29
20 sec
Q.
What must you have on your data before you can apply any filters?
30
20 sec
Q.
I can filter data by
31
20 sec
Q.
What is Microsoft Excel's main function?
32
20 sec
Q.
To set up my spreadsheet with titles at the top of each page, I would need to turn on
33
20 sec
Q.
The new window view allows you to
34
20 sec
Q.
What must be followed when working with complex formulas in order to get the correct answer?
