Exam 2: Excel 2019

Kamala enters a date as the start date in cell E2 and a list of holidays in cells F2:F5. Now she wants to add 30 workdays to the start date. She can do this using the following formula: = WORKDAY (E2, 30, F2:F5).

(True/False)

4.9/5

(33)

Question 101

Henri wants to convert a workbook to PDF so that he can print it in high quality using a commercial printer. He can do so by clicking on Page Layout > Save As > (Enter name in ) File name box > Save As type list > PDF > Minimum Size (publishing online) > Options > OK > Save.

(True/False)

4.8/5

(42)

Question 102

To remove validation circles, you can use the Clear Validation Circles command or you can _____.

(Multiple Choice)

4.8/5

(40)

Question 103

Leigh-Ann used a slicer to filter a table on the Department field. Which of the following buttons should she click on the slicer to redisplay data for all the departments?

(Multiple Choice)

4.9/5

(39)

Question 104

If you see a cells with blue fills of varying lengths representing the values, the cells most likely have ________ applied to them.

(Multiple Choice)

4.8/5

(36)

Question 105

A(n) _____ is a program that adds commands and features to applications such as Microsoft Excel.

(Multiple Choice)

4.9/5

(38)

Question 106

Esperanza wants to save a series of commands she performs often. Which of the following should she do?

(Multiple Choice)

4.8/5

(38)

Question 107

You can use the GETPIVOTDATA function to display a summarized PivotTable on a worksheet.

(True/False)

4.8/5

(32)

Question 108

PivotTables are automatically sorted in ascending order if the fields contain numeric data.

(True/False)

4.9/5

(33)

Question 109

To redisplay a hidden worksheet, you _____ the worksheet.

(Multiple Choice)

4.8/5

(41)

Question 110

Flash Fill enters text based on patterns it finds in the data.

(True/False)

4.9/5

(37)

Question 111

Helen wants to resize slicer buttons to exact dimensions. What can she use to do so?

(Multiple Choice)

4.7/5

(31)

Question 112

To enter a typed number into a cell, you can press Tab or Backspace .

(True/False)

4.9/5

(37)

Question 113

Which of the following options can you set to make sure a worksheet will print on one page?

(Multiple Choice)

4.7/5

(32)

Question 114

To insert only the current date in cell B1, use the NOW function in cell B1.

(True/False)

4.9/5

(32)

Question 115

Which of the following is true about adding cell borders?

(Multiple Choice)

4.8/5

(34)

Question 116

Before inserting sparklines into cells, make sure the cells are blank because sparklines replace cell contents.

(True/False)

4.8/5

(32)

Question 117

By default, table styles override the formatting applied to individual table cells.

(True/False)

4.8/5

(38)

Question 118

Which of the following is a simpler way to write the following formula: June!C5+July!C5+Aug!C5?

(Multiple Choice)

4.8/5

(43)

Question 119

Cell A4 contains the time 10:27 pm. To round that time to the nearest 30-minute interval, use the formula =MROUND(A4,0:30).

(True/False)

4.9/5

(34)

Question 120

Showing 101 - 120 of 503

Kamala enters a date as the start date in cell E2 and a list of holidays in cells F2:F5. Now she wants to add 30 workdays to the start date. She can do this using the following formula: = WORKDAY (E2, 30, F2:F5).

Henri wants to convert a workbook to PDF so that he can print it in high quality using a commercial printer. He can do so by clicking on Page Layout > Save As > (Enter name in ) File name box > Save As type list > PDF > Minimum Size (publishing online) > Options > OK > Save.

To remove validation circles, you can use the Clear Validation Circles command or you can _____.

Leigh-Ann used a slicer to filter a table on the Department field. Which of the following buttons should she click on the slicer to redisplay data for all the departments?

If you see a cells with blue fills of varying lengths representing the values, the cells most likely have ________ applied to them.

A(n) _____ is a program that adds commands and features to applications such as Microsoft Excel.

Esperanza wants to save a series of commands she performs often. Which of the following should she do?

You can use the GETPIVOTDATA function to display a summarized PivotTable on a worksheet.

PivotTables are automatically sorted in ascending order if the fields contain numeric data.

To redisplay a hidden worksheet, you _____ the worksheet.

Flash Fill enters text based on patterns it finds in the data.

Helen wants to resize slicer buttons to exact dimensions. What can she use to do so?

To enter a typed number into a cell, you can press Tab or Backspace .

Which of the following options can you set to make sure a worksheet will print on one page?

To insert only the current date in cell B1, use the NOW function in cell B1.

Which of the following is true about adding cell borders?

Before inserting sparklines into cells, make sure the cells are blank because sparklines replace cell contents.

By default, table styles override the formatting applied to individual table cells.

Which of the following is a simpler way to write the following formula: June!C5+July!C5+Aug!C5?

Cell A4 contains the time 10:27 pm. To round that time to the nearest 30-minute interval, use the formula =MROUND(A4,0:30).

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters