FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Excel 2019

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 181

True/False

Review LaterAdd Note

Review Later

To clear all the comments from a workbook, you must delete them one at a time.

A) True
B) False

Correct Answer

verified

Show Answer

Question 182

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following chart elements identifies the purpose of a chart?

A) Legend
B) Gridlines
C) Vertical axis
D) Chart title

E) None of the above
F) All of the above

Correct Answer

verified

Show Answer

Question 183

True/False

Review LaterAdd Note

To list the Product Type field values across the top of a PivotTable, add the Product Type field to the Rows area of the PivotTable Fields pane.

To view a worksheet without headers, margins, and rulers, use Page Layout view.

Che has a Pie PivotChart that he wants to display with in a three-dimensional format. Which of the following should he do?

When you create a PivotChart directly from data, what does Excel do?

Sam wants to count the number of cells in the range B1: B20 that contain numbers. Which of the following formulas should he use?

Ursula wants to freeze the header row so that it remains visible while she scrolls down the worksheet. To do so, she can click the View tab and then click Freeze Top Row.

A predesigned combination of formats, such as font size and color, is called a cell default.

The score of a student in two subjects are inserted in B2 and C2 cell and the passing score for each subject is 60. which of these functions will you insert in D2 cell to get FALSE as the result if the student has passed and TRUE as the result if the student has failed?

Maria has a line chart that shows expense amounts on the vertical axis. What can she do to display the values as dollar amounts?

When you copy and paste a formula with absolute cell references, Excel substitutes new references to reflect the new formula location.

Which of the following keys will you press after clicking on a chart to remove it from an Excel sheet but keep the data intact?

How many actions does the Undo button let you reverse?

Lilia wants to save a workbook as a read-only file. She should encrypt the workbook with a password.

Angie created a PivotTable that includes two levels of data in each row, but now shows only the first level of data. She can click the Expand button in one row to display both levels of data.

You can open the Visual Basic Editor by clicking the Visual Basic button in the Code group on the Developer tab.

To add a worksheet to a workbook, you would use the New formula tab below the worksheet.

If you change theme colors, you must restore the original colors before closing Excel.

A student enters the names of months in cells A2 to A5 with the heading "Month" in cell A1. Then he enters the number of days in each moth in cells B2 to B5 with the heading "Days" in cell B2. In order to arrange the names of the months in cells A6 to E6 with heading "Month" in cell A6 and the number of days each month in cells A7 to E7 with heading "Days" in cell A7, he can use the formula =TRANSPOSE(A1:B5).