Microsoft Excel Quiz

How do you resize a graph?

• A. Click the graph then click and drag any of the eight handles in the edges of the graph.

• B. Select the table then press right click, a window will appear, select the Width change the value desired then select height change the value desired.

• C. Select the table the press Ctrl + Arrow Keys.

• D. You can't change the size of graphs.

Which Ribbon Menu is needed to add a Chart?

• A. Home

• B. Insert

• C. Page Layout

• D. Cell Formatting

With this formula = Expense!C12, what does the Expense! part means?

• A. It a variable that allows quick reference of a value.

• B. It is formula label, allowing the user to manage all the formula.

• C. It indicates that the c12 to be displayed is on the sheet Expense

• D. This is not a proper use of the formula.

Which Ribbon Menu is needed to be selected to change the font?

• A. Home

• B. Insert

• C. Page Layout

• D. Cell Formatting

How do you resize a column or width?

• A. Select the cell the press right click, select format cell then change height and width values.

• B. In the Formula bar type (h[value]:w[value]).

• C. Click the cell then in the ribbon select format cell then change height and width values.

• D. Click and drag the column or row heading.

What is the formula that will subtract the contents of the cells A7 and A8?

• A. A7 - A8

• B. = A7 - A8

• C. A7 - A8 =

• D. =SUM (A7:A8)

Harold wants to drag select cells A1 to D7. How can he accomplish this?

• A. Long press Alt then click A1 then click D7.

• B. While pressing shift select the A1 then D7

• C. In the formula bar type A1:D7

• D. Press Ctrl + A.

Based on the activities, what is the use of a Spreadsheet software?

• A. It allows the data to be stored, organized and analyzed.

• B. It gives the user the ability to create tables.

• C. It enables users to record words and numbers.

• D. It is a software that allows input, editing, formatting and output of text

What is the formula that will add the contents of the cells C1 and C10?

• A. C1 + C10

• B. = C1 + C10

• C. C1 + C10 =

• D. SUM (C1:C3)

How do you rename a graph into "First Data" in Microsoft Excel?

• A. Press right click then select rename, a window will appear then type "First Data".

• B. Press Ctrl + A then Ctrl + R, rename the chart to "First Data"

• C. Double click the name of the chart and type "First Data".

• D. Graph names can't be changed as they follow the name from the selected data.