Help are these correct answers any experts new to excel

[newbie1985]

Which of the following would you type into an Excel "cell" to calculate: 150 plus 10?
150+10
=150+10
=150 plus 10 (My answer =150+10)

What does the “Save As” function do in both Excel and Word?
It saves and moves the document to a different location
It saves and uploads the document to an online storage application, such as Dropbox or iCloud
It renames the current document and keeps a copy of the document in its original name without any changes
It overwrites the original document with the current document so you don’t have a copy of the original document (My answer is It saves and moves the document to a different location)

How would you add a new sheet to an Excel workbook?
By double clicking on the sheet currently in the workbook
By going to the File tab on the Ribbon and opening a new workbook
By clicking on the plus button next to the latest sheet at the bottom of the workbook
By right clicking on the sheet currently in the workbook and selecting “duplicate” (My answer is By going to the File tab on the Ribbon and opening a new workbook)

Which of the following is NOT a way to enter data into a cell?
Copying and pasting data from a different spreadsheet or document
Going to the Insert tab on the Ribbon and clicking on the “Text” function
Entering manually into the formula bar
Typing directly into the cell

How would you change data in cells from numbers to currency?
Highlight cells, right click and select “Format cells”, and select “Number”
Re-enter the data with pound signs in front of the numbers
Highlight cells, right click and select “Format cells”, and select “Currency”
Highlight cells, right click and select “Format cells”, and select “Accounting” (My answer is Highlight cells, right click and select “Format cells”, and select “Currency”)

This question uses Cell references. Which of the following would you type into an Excel "cell" to calculate: Contents of cell F4 plus 18?
4F plus 18
=F4+18
(F,4) plus 18 (My answer is 4F plus 18)

You have a table of data that shows the cost of your monthly food shop for a year. How would you filter the table so that you’re only presented with May’s monthly food bill?
Click on the drop-down arrow of the months’ column, untick the “Select all” box, and tick the box for May
Highlight the whole table, go the Home tab on the Ribbon, click on the Sort and Filter button, and select “Sort A to Z”
Copy and paste the table into a new sheet, and delete all of the data except that for May
Click on the drop-down arrow of the months’ column, and untick the box for May (My answer is ow of the months’ column, untick the “Select all” box, and tick the box for May)

You have a table of data showing your monthly outgoings. How would you sort the table to show the most expensive months to the least expensive months?
Click into the table, go to the Data tab on the Ribbon, click on the Sort command, then sort by “Total”, and change the order to “Largest to Smallest”
Re-enter the data of the table from the most expensive months to the cheapest months
Click into the table, go to the Formulas tab on the Ribbon, click on the AutoSum command, and select “Max”
Highlight the whole table, go the Home tab on the Ribbon, click on the Sort and Filter button, and select “Sort Z to A”


How would you insert a graph based on a table of data?
Highlight the table (except for totals if there are any), go to the Insert tab on the Ribbon, click on the Recommended Charts command, select a graph and click OK
Highlight the table and click on the Sparklines command
Highlight the table (except for totals if there are any), and press Ctrl and G together
Highlight the table and click on the Pivot Chart command


When printing your spreadsheet, how can you change the settings so that it will print out horizontally and with everything on 1 page?
Press Ctrl and P together and accept all of the settings
Go to the File tab on the Ribbon, select Print, change the portrait orientation to landscape orientation, then click the Print command
Go to the File tab on the Ribbon, select Print, click on the No Scaling option and select the “Fit Sheet on One Page” option. Then click the Print command
Go to the File tab on the Ribbon, select Print, change the portrait orientation to landscape orientation. Then click on the No Scaling option and select the “Fit Sheet on One Page” option. Then click the Print command

 

[Joe4]

Which of the following would you type into an Excel "cell" to calculate: 150 plus 10?
150+10
=150+10
=150 plus 10 (My answer =150+10)

What does the “Save As” function do in both Excel and Word?
It saves and moves the document to a different location
It saves and uploads the document to an online storage application, such as Dropbox or iCloud
It renames the current document and keeps a copy of the document in its original name without any changes
It overwrites the original document with the current document so you don’t have a copy of the original document (My answer is It saves and moves the document to a different location)

How would you add a new sheet to an Excel workbook?
By double clicking on the sheet currently in the workbook
By going to the File tab on the Ribbon and opening a new workbook
By clicking on the plus button next to the latest sheet at the bottom of the workbook
By right clicking on the sheet currently in the workbook and selecting “duplicate” (My answer is By going to the File tab on the Ribbon and opening a new workbook)

Which of the following is NOT a way to enter data into a cell?
Copying and pasting data from a different spreadsheet or document
Going to the Insert tab on the Ribbon and clicking on the “Text” function
Entering manually into the formula bar
Typing directly into the cell

How would you change data in cells from numbers to currency?
Highlight cells, right click and select “Format cells”, and select “Number”
Re-enter the data with pound signs in front of the numbers
Highlight cells, right click and select “Format cells”, and select “Currency”
Highlight cells, right click and select “Format cells”, and select “Accounting” (My answer is Highlight cells, right click and select “Format cells”, and select “Currency”)

This question uses Cell references. Which of the following would you type into an Excel "cell" to calculate: Contents of cell F4 plus 18?
4F plus 18
=F4+18
(F,4) plus 18 (My answer is 4F plus 18)

You have a table of data that shows the cost of your monthly food shop for a year. How would you filter the table so that you’re only presented with May’s monthly food bill?
Click on the drop-down arrow of the months’ column, untick the “Select all” box, and tick the box for May
Highlight the whole table, go the Home tab on the Ribbon, click on the Sort and Filter button, and select “Sort A to Z”
Copy and paste the table into a new sheet, and delete all of the data except that for May
Click on the drop-down arrow of the months’ column, and untick the box for May (My answer is ow of the months’ column, untick the “Select all” box, and tick the box for May)

You have a table of data showing your monthly outgoings. How would you sort the table to show the most expensive months to the least expensive months?
Click into the table, go to the Data tab on the Ribbon, click on the Sort command, then sort by “Total”, and change the order to “Largest to Smallest”
Re-enter the data of the table from the most expensive months to the cheapest months
Click into the table, go to the Formulas tab on the Ribbon, click on the AutoSum command, and select “Max”
Highlight the whole table, go the Home tab on the Ribbon, click on the Sort and Filter button, and select “Sort Z to A”


How would you insert a graph based on a table of data?
Highlight the table (except for totals if there are any), go to the Insert tab on the Ribbon, click on the Recommended Charts command, select a graph and click OK
Highlight the table and click on the Sparklines command
Highlight the table (except for totals if there are any), and press Ctrl and G together
Highlight the table and click on the Pivot Chart command


When printing your spreadsheet, how can you change the settings so that it will print out horizontally and with everything on 1 page?
Press Ctrl and P together and accept all of the settings
Go to the File tab on the Ribbon, select Print, change the portrait orientation to landscape orientation, then click the Print command
Go to the File tab on the Ribbon, select Print, click on the No Scaling option and select the “Fit Sheet on One Page” option. Then click the Print command
Go to the File tab on the Ribbon, select Print, change the portrait orientation to landscape orientation. Then click on the No Scaling option and select the “Fit Sheet on One Page” option. Then click the Print command

Please do not expect us to do your assignment/homework/test for you.
That would be unethical.