Podcast
Questions and Answers
What is the correct method to insert a picture in a Microsoft Excel worksheet?
What is the correct method to insert a picture in a Microsoft Excel worksheet?
Which tab do you need to visit to remove a page break in Excel?
Which tab do you need to visit to remove a page break in Excel?
Which function would you use to find the total in a column within Excel?
Which function would you use to find the total in a column within Excel?
What is one way to start a new spreadsheet in Excel?
What is one way to start a new spreadsheet in Excel?
Signup and view all the answers
To insert functions as formulas in Excel, which sequence is correct?
To insert functions as formulas in Excel, which sequence is correct?
Signup and view all the answers
Which of the following methods can be used to insert a new column in MS Excel?
Which of the following methods can be used to insert a new column in MS Excel?
Signup and view all the answers
How can you insert a new sheet in MS Excel?
How can you insert a new sheet in MS Excel?
Signup and view all the answers
Which tab do you navigate to when adding Clipart in MS Excel?
Which tab do you navigate to when adding Clipart in MS Excel?
Signup and view all the answers
What is one of the methods to insert a new row in MS Excel?
What is one of the methods to insert a new row in MS Excel?
Signup and view all the answers
What functionality does MS Excel provide regarding data from external files?
What functionality does MS Excel provide regarding data from external files?
Signup and view all the answers
What is the correct syntax for the SUMIF function in MS Excel?
What is the correct syntax for the SUMIF function in MS Excel?
Signup and view all the answers
What must be done to change the reference style from A1 to R1C1 in Excel?
What must be done to change the reference style from A1 to R1C1 in Excel?
Signup and view all the answers
What would happen if you format a cell as a date and input 36526?
What would happen if you format a cell as a date and input 36526?
Signup and view all the answers
What is the first step to open a new spreadsheet in MS Excel?
What is the first step to open a new spreadsheet in MS Excel?
Signup and view all the answers
Which option is NOT a formatting category in Excel?
Which option is NOT a formatting category in Excel?
Signup and view all the answers
What color should the total marks be shaded in according to the formatting instructions?
What color should the total marks be shaded in according to the formatting instructions?
Signup and view all the answers
What does the General number format do in Excel cells?
What does the General number format do in Excel cells?
Signup and view all the answers
What is one of the aims of formatting in a spreadsheet?
What is one of the aims of formatting in a spreadsheet?
Signup and view all the answers
What does the COUNT function do in MS Excel?
What does the COUNT function do in MS Excel?
Signup and view all the answers
What is the correct syntax for the AVERAGE function in MS Excel?
What is the correct syntax for the AVERAGE function in MS Excel?
Signup and view all the answers
Which function would you use to find the largest number in a set of values?
Which function would you use to find the largest number in a set of values?
Signup and view all the answers
In the syntax of COUNTIF, what does 'criteria' refer to?
In the syntax of COUNTIF, what does 'criteria' refer to?
Signup and view all the answers
How do you calculate the total sales for a specific month using SUMIF?
How do you calculate the total sales for a specific month using SUMIF?
Signup and view all the answers
What value is returned by the MIN function if applied to the values 10, 20, and 5?
What value is returned by the MIN function if applied to the values 10, 20, and 5?
Signup and view all the answers
What happens when you press enter after typing in a formula in MS Excel?
What happens when you press enter after typing in a formula in MS Excel?
Signup and view all the answers
What input does the MAX function require?
What input does the MAX function require?
Signup and view all the answers
What is the first step to open a new PowerPoint Presentation?
What is the first step to open a new PowerPoint Presentation?
Signup and view all the answers
Where do you go to create a presentation based on a design template?
Where do you go to create a presentation based on a design template?
Signup and view all the answers
What action should you take to create a presentation using a design template after previewing it?
What action should you take to create a presentation using a design template after previewing it?
Signup and view all the answers
What does clicking the Blank Presentation thumbnail do?
What does clicking the Blank Presentation thumbnail do?
Signup and view all the answers
What command should be used to display the Backstage view?
What command should be used to display the Backstage view?
Signup and view all the answers
Which of the following options is NOT a valid method to open a new PowerPoint Presentation?
Which of the following options is NOT a valid method to open a new PowerPoint Presentation?
Signup and view all the answers
What must you do to view alternative color schemes and graphic backgrounds for a presentation design template?
What must you do to view alternative color schemes and graphic backgrounds for a presentation design template?
Signup and view all the answers
What is the final result of following the procedure outlined for creating a presentation in PowerPoint?
What is the final result of following the procedure outlined for creating a presentation in PowerPoint?
Signup and view all the answers
Which menu path allows you to print presentations as handouts?
Which menu path allows you to print presentations as handouts?
Signup and view all the answers
What happens to a hyperlink when the object it is attached to is deleted?
What happens to a hyperlink when the object it is attached to is deleted?
Signup and view all the answers
What file type is created for a standalone presentation viewer in PowerPoint?
What file type is created for a standalone presentation viewer in PowerPoint?
Signup and view all the answers
Which of the following is NOT an option for accessing the Insert Hyperlink box?
Which of the following is NOT an option for accessing the Insert Hyperlink box?
Signup and view all the answers
When generating handouts, how many slides can you choose to display per page?
When generating handouts, how many slides can you choose to display per page?
Signup and view all the answers
Which steps are necessary to edit a hyperlink attached to an object?
Which steps are necessary to edit a hyperlink attached to an object?
Signup and view all the answers
To create a new PowerPoint presentation, which of the following steps is NOT required?
To create a new PowerPoint presentation, which of the following steps is NOT required?
Signup and view all the answers