Microsoft Excel Basics Quiz

Play an AI-generated podcast conversation about this lesson

What is the correct method to insert a picture in a Microsoft Excel worksheet?

Navigate to Page Layout Tab → Page Setup → Breaks

Navigate to Insert Tab → Illustrations → Pictures (correct)

Go to the Data Tab → Get Data → From Web

Use the Run Command and type 'insert picture'

Which tab do you need to visit to remove a page break in Excel?

Page Layout Tab → Breaks (correct)

Review Tab → Changes

Insert Tab → Symbols

Data Tab → Get Data

Which function would you use to find the total in a column within Excel?

Use the Insert Tab → Symbols → Equations

Use the Data Tab → Get Data

Use mathematical operations such as Addition or Subtraction (correct)

Use the Insert Tab → Illustrations

What is one way to start a new spreadsheet in Excel?

Use Windows Logo + R and enter 'excel' Signup and view all the answers

To insert functions as formulas in Excel, which sequence is correct?

Insert Tab → Symbols → Equations Signup and view all the answers

Which of the following methods can be used to insert a new column in MS Excel?

Right Click over the column identifier and tap on Insert Signup and view all the answers

How can you insert a new sheet in MS Excel?

Navigate to Home Tab → Cells Section → Insert → Insert Sheet Signup and view all the answers

Which tab do you navigate to when adding Clipart in MS Excel?

Insert Tab Signup and view all the answers

What is one of the methods to insert a new row in MS Excel?

Right Click over the left row identifier and tap on Insert Signup and view all the answers

What functionality does MS Excel provide regarding data from external files?

You can copy paste or insert data from various external files like web content or documents. Signup and view all the answers

What is the correct syntax for the SUMIF function in MS Excel?

SUMIF(range, criteria, sum_range) Signup and view all the answers

What must be done to change the reference style from A1 to R1C1 in Excel?

Clear the R1C1 reference style box in the Formulas tab Signup and view all the answers

What would happen if you format a cell as a date and input 36526?

The cell will display 1/1/2000 Signup and view all the answers

What is the first step to open a new spreadsheet in MS Excel?

Use the Windows Logo + R command to run Excel Signup and view all the answers

Which option is NOT a formatting category in Excel?

Function Signup and view all the answers

What color should the total marks be shaded in according to the formatting instructions?

Blue Signup and view all the answers

What does the General number format do in Excel cells?

Displays numbers exactly as they are entered Signup and view all the answers

What is one of the aims of formatting in a spreadsheet?

To add visual appeal and clarity to the data Signup and view all the answers

What does the COUNT function do in MS Excel?

Counts the number of cells that contain numbers Signup and view all the answers

What is the correct syntax for the AVERAGE function in MS Excel?

=AVERAGE(number1,number2,...) Signup and view all the answers

Which function would you use to find the largest number in a set of values?

MAX Signup and view all the answers

In the syntax of COUNTIF, what does 'criteria' refer to?

The specific condition that must be met Signup and view all the answers

How do you calculate the total sales for a specific month using SUMIF?

Using the syntax =SUMIF(month_range, criteria, sales_range) Signup and view all the answers

What value is returned by the MIN function if applied to the values 10, 20, and 5?

5 Signup and view all the answers

What happens when you press enter after typing in a formula in MS Excel?

The formula is evaluated and the result is displayed Signup and view all the answers

What input does the MAX function require?

At least one numerical value Signup and view all the answers

What is the first step to open a new PowerPoint Presentation?

Use Windows Logo + R then type 'powerpnt' Signup and view all the answers

Where do you go to create a presentation based on a design template?

Click the File tab and then New in the Backstage view Signup and view all the answers

What action should you take to create a presentation using a design template after previewing it?

Click the Create button in the preview window Signup and view all the answers

What does clicking the Blank Presentation thumbnail do?

Starts a new presentation without any pre-set design Signup and view all the answers

What command should be used to display the Backstage view?

Click the File tab Signup and view all the answers

Which of the following options is NOT a valid method to open a new PowerPoint Presentation?

Using a web browser to open PowerPoint Online Signup and view all the answers

What must you do to view alternative color schemes and graphic backgrounds for a presentation design template?

Open the preview window after selecting a thumbnail Signup and view all the answers

What is the final result of following the procedure outlined for creating a presentation in PowerPoint?

A new presentation with selected slides and styles will be created Signup and view all the answers

Which menu path allows you to print presentations as handouts?

File → Print → Settings → Handouts Signup and view all the answers

What happens to a hyperlink when the object it is attached to is deleted?

The hyperlink is deleted as well Signup and view all the answers

What file type is created for a standalone presentation viewer in PowerPoint?

.ppsx Signup and view all the answers

Which of the following is NOT an option for accessing the Insert Hyperlink box?

Select the object, then press Alt+H Signup and view all the answers

When generating handouts, how many slides can you choose to display per page?

Any number of your choice Signup and view all the answers

Which steps are necessary to edit a hyperlink attached to an object?

Select the object and right-click to choose Edit Hyperlink Signup and view all the answers

To create a new PowerPoint presentation, which of the following steps is NOT required?

Choose a template Signup and view all the answers