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/49
Score 0
To find the largest value in a cell range, use the MIN function.
30
True
False
Q 2/49
Score 0
To show formulas instead of values, you can click CTRL+ACCENT MARK (`).
30
False
True
49 questions
Q.
To find the largest value in a cell range, use the MIN function.
1
30 sec
Q.
To show formulas instead of values, you can click CTRL+ACCENT MARK (`).
2
30 sec
Q.
To move a worksheet within a workbook, you can drag its sheet tab to a new location.
3
30 sec
Q.
To format the cell value 44.54 as 44.540, you can Increase Decimal button.
4
30 sec
Q.
You can edit cell contents directly in the cell itself.
5
30 sec
Q.
Brendan wants to print only part of a worksheet he completed. To do do, he must first copy the part he wants to print to a new blank worksheet.
6
30 sec
Q.
When you enter a number in a worksheet cell, Excel automatically left-aligns the number.
7
30 sec
Q.
When you change cell contents to italics, you are changing the cell's alignment.
8
30 sec
Q.
When you click the AutoSum button, Excel enters a formula with the SUM function into the active cell.
9
30 sec
Q.
When you insert a worksheet row, you insert a new row above the current row and the sheet contents below the new row move downward.
10
30 sec
Q.
Currency is an example of a number format.
11
30 sec
Q.
When you run the spelling checker in a workbook, Excel automatically checks the spelling in all worksheets at once.
12
30 sec
Q.
To move data one space to the right in a cell, you can use the Increase Space button.
13
30 sec
Q.
To print worksheet contents on a page that is wider than it is tall, you can use portrait orientation.
14
30 sec
Q.
When you copy cell contents, the data is removed from its original location and placed on the Clipboard.
15
30 sec
Q.
Josh wants to distribute a workbook to his colleagues. His only option is to print the workbook and provide a copy to each colleague.
16
30 sec
Q.
Decreasing a cell's indent moves its contents to the right one space.
17
30 sec
Q.
Logan wants to insert the current system date and time in a cell. To do so, he can used the NOW function.
18
30 sec
Q.
Cell B2 contains the total score for a student. The passing score is 60. Which of the following formulas checks whether the student will pass or fail?
19
30 sec
Q.
In the formula =B6$B$2, which of the following describes $B$2?
20
30 sec
Q.
How many actions does the Undo button let you reverse?
21
30 sec
Q.
To pasted copied cell contents with values only, not including formatting, which of the following can you use?
22
30 sec
Q.
Caleb wants to assign a value to a cell based on a logical test. Which of the following functions should he use?
23
30 sec
Q.
When Skylar clicks a chart, buttons appear to the right of the chart. Which button should she click to enhance the appearance of the chart?
24
30 sec
Q.
A ______ defines the appearance and the shape of the letters, numbers, and special characters.
25
30 sec
Q.
Which of the following is a shortcut for performing a common calculation in a formula?
26
30 sec
Q.
To select nonadjacent cells on a worksheet, you can press and hold _____ while selecting each cell.
27
30 sec
Q.
You can double-click the Format Painter button when you want to _____.
28
30 sec
Q.
Which of the following is true when you delete a cell?
29
30 sec
Q.
The default font for an entire workbook is ____-point Calibri.
30
30 sec
Q.
The spell checker flags your company's name as a misspelling. Which of the following will stop the spell checker from flagging later occurrences in the worksheet?
31
30 sec
Q.
Madison selects cell A12 on a worksheet. What happens when she drags the fill handle to the range B12:G12?
32
30 sec
Q.
To copy a cell's formatting to another cell, which of the following can you use?
33
30 sec
Q.
To select a single worksheet cell so you can work with it, which of the following should you do?
34
30 sec
Q.
You have selected a cell containing a formula. Which of the following can you use to copy that formula to an adjacent cell?
35
30 sec
Q.
To change the name of a worksheet you rename the ______.
36
30 sec
Q.
When working with a large worksheet, you can split the window into ____ panes to view different parts of the worksheet at the same time.
37
30 sec
Q.
After you delete a worksheet column, ____.
38
30 sec
Q.
To combine multiple cells into one cell, which of the following do you use?
39
30 sec
Q.
Blaise entered 0.31251 in cell B8. When he clicked the Percent Style button on the Home tab, Excel multiplied the value in cell B8 by ___, rounded the result to the nearest percentage, and added a percent sign.
40
30 sec
Q.
Which of the following charts should you create when you want to see how each part of the chart relates to the whole?
41
30 sec
Q.
Which of the following buttons do you click on the Chart Design tab to change a column chart to a bar chart?
42
30 sec
Q.
Which of the following formulas is the most efficient way to calculate the total of cells B6, B7, B8, B9, and B10?
43
30 sec
Q.
You receive a worksheet in which the rows are numbered 1,2,3,5,6. This means that row 4 is ___.
44
30 sec
Q.
Kami inserted the formula =A1 in cell D1, and then copied the formula to cell D2. What is the formula in cell D2?
45
30 sec
Q.
To format a range so that all values greater than $500 appear in read, which of the following can you use?
46
30 sec
Q.
To rotate cell contents to an exact value, you change its _____.
47
30 sec
Q.
To print your worksheet on a sheet of paper larger than 8.5" x 11", which Excel tab would you use?
48
30 sec
Q.
When you copy and paste a formula, Excel adjust the cell references so that the pasted formula contains new cell references corresponding to the new location. What do you call this type of cell reference?