FIN3704 Assignment 1 (COMPLETE ANSWERS) Semester 1 2025 (656601) - DUE 10 April 2025

Question 1 Correct Mark 1.00 out of 1.00 QUIZ The excel home tab contains the most commonly used commands, including the a. Pivot table; recommended pivot tables and tables b. Margins, Orientation and Size c. Cut; Copy; Paste buttons; formatting options, find and replace  d. Spelling, thesaurus and workbook statistics Your answer is correct. Question 2 Correct Mark 1.00 out of 1.00 Question 3 Correct Mark 1.00 out of 1.00 The excel insert tab contains buttons for Inserting ……. a. pivot tables, charts, print, open and options b. pivots tables, charts, save, close, and options c. pivot tables, charts, pictures, shapes, text boxes and questions  d. Cut, copy, paste formatting options; find and replace Your answer is correct. Press……... to save the active file with its current file name, location, and file format. a. Alt + S b. Ctrl + S  c. Alt + Tab + Esc d. Ctrl + Alt +Esc Your answer is correct. Question 4 Correct Mark 1.00 out of 1.00 Question 5 Correct Mark 1.00 out of 1.00 The worksheet is a matrix of cells……… rows by……. Columns a. 1036465; 14263 b. 1025354; 13252 c. 1048576; 16384  d. 1046453; 15273 Your answer is correct. What are the two principal ways of moving around within the worksheet area? a. Arrow or tab keys and Num Lock b. Arrow or tab keys and mouse  c. Arrow or tab keys and keypad d. Arrow or tab keys and sheet tab Question 6 Correct Mark 1.00 out of 1.00 Question 7 Correct Mark 1.00 out of 1.00 Which sign in the formula specifies the fixed columns or rows? a. * b. $  c. ; d. % Your answer is correct. Description: In Excel, an absolute cell reference is a cell name that includes a dollar sign ($). Type dollar signs before thecolumn letter and row number to create a complete reference. The GEOMEAN function takes up to…… cell addresses (or ranges) separated by commas. a. 220 b. 240 c. 255  d. 260 Your answer is correct. Question 8 Correct Mark 1.00 out of 1.00 Question 9 Correct Mark 1.00 out of 1.00 If a worksheet you create may be used on older versions of Excel, you should run the compatibility checker before saving thefile. This will warn of compatibility problems, including using the new dot functions. To use the Compatibility Checker…… a. Click the File tab and then Info; Click the Browser View Options button and then choose to click Ok. b. Click the File tab and then Info; Click the Check for Issues button and then choose Check Compatibility.  c. Click the File tab and then Info; Click the Check for Issues button and then choose Check Accessibility. d. Click the File tab and Infor; Click the Manage Workbook button and choose to Check out. Your answer is correct. . To clear the contents of the selected cells, use the command________ a. Clear All b. Clear Delete c. Delete d. Clear Contents  Your answer is correct. Question 10 Correct Mark 1.00 out of 1.00 Description: We need to use the Clear Content command to clear the content of the selected cells. Precise Contents willeliminate the data and not delete the formats. Which of the following would you use to make a bar diagram? a. Edit Chart b. Format Chart c. Insert Chart  d. Tool Chart Your answer is correct. FIN3704-25-S1  Welcome Message  Assessment 1 Question 1 Not yet answered Marked out of 1.00 QUIZ The excel home tab contains the most commonly used commands, including the a. Pivot table; recommended pivot tables and tables b. Margins, Orientation and Size c. Cut; Copy; Paste buttons; formatting options, find and replace d. Spelling, thesaurus and workbook statistics Clear my choice Time left 0:57:50 Question 2 Not yet answered Marked out of 1.00 The excel insert tab contains buttons for Inserting ……. a. pivot tables, charts, print, open and options b. pivots tables, charts, save, close, and options c. pivot tables, charts, pictures, shapes, text boxes and questions d. Cut, copy, paste formatting options; find and replace Clear my choice FIN3704-25-S1  Welcome Message  Assessment 1 Question 3 Not yet answered Marked out of 1.00 Question 4 Not yet answered Marked out of 1.00 QUIZ Press……... to save the active file with its current file name, location, and file format. a. Alt + S b. Ctrl + S c. Alt + Tab + Esc d. Ctrl + Alt +Esc Clear my choice The worksheet is a matrix of cells……… rows by……. Columns a. 1036465; 14263 b. 1025354; 13252 c. 1048576; 16384 d. 1046453; 15273 Clear my choice Time left 0:56:20 FIN3704-25-S1  Welcome Message  Assessment 1 Question 5 Not yet answered Marked out of 1.00 Question 6 Not yet answered Marked out of 1.00 QUIZ What are the two principal ways of moving around within the worksheet area? a. Arrow or tab keys and Num Lock b. Arrow or tab keys and mouse c. Arrow or tab keys and keypad d. Arrow or tab keys and sheet tab Clear my choice Which sign in the formula specifies the fixed columns or rows? a. * b. $ c. ; d. % Clear my choice Time left 0:53:36 FIN3704-25-S1  Welcome Message  Assessment 1 Question 7 Not yet answered Marked out of 1.00 Question 8 Not yet answered Marked out of 1.00 QUIZ Description: In Excel, an absolute cell reference is a cell name that includes a dollar sign ($). Type dollar signs before thecolumn letter and row number to create a complete reference. The GEOMEAN function takes up to…… cell addresses (or ranges) separated by commas. a. 220 b. 240 c. 255 d. 260 Clear my choice If a worksheet you create may be used on older versions of Excel, you should run the compatibility checker before saving thefile. This will warn of compatibility problems, including using the new dot functions. To use the Compatibility Checker…… a. Click the File tab and then Info; Click the Browser View Options button and then choose to click Ok. b. Click the File tab and then Info; Click the Check for Issues button and then choose Check Compatibility. c. Click the File tab and then Info; Click the Check for Issues button and then choose Check Accessibility. d. Click the File tab and Infor; Click the Manage Workbook button and choose to Check out. Clear my choice Time left 0:51:57 FIN3704-25-S1  Welcome Message  Assessment 1 Question 9 Not yet answered Marked out of 1.00 Question 10 Not yet answered Marked out of 1.00 QUIZ To clear the contents of the selected cells, use the command________ a. Clear All b. Clear Delete c. Delete d. Clear Contents Clear my choice Description: We need to use the Clear Content command to clear the content of the selected cells. Precise Contents willeliminate the data and not delete the formats. Which of the following would you use to make a bar diagram? a. Edit Chart b. Format Chart c. Insert Chart d. Tool Chart