Cgs1000 Practice Final Exam 365/2019 Chambers
Questions And Answers With Solutions 2026
Check for new updates to Office - correct answer-Incorrect: File > Account > Whats New
In cell D15, enter a formula using a counting function to count the number of cells in the "Billable ?"
column (cells D2:D14) that are not blank. - correct answer-
Formulas tab > Function Library, click More Functions, point to statistical and select COUNTA from t
he list. Click and drag to select cells D2:D14. Click OK.
Insert an index based on the Classic format. The entries should display in two columns. -
correct answer-
Click the references tab. In the index group, click the insert index button. Click the formats drop down
arrow and select Classic. Click OK.
A company creates a by using a wireless access point (WAP) and an Internet connection. Select
the two correct answers, then click Done. - correct answer-Wireless LAN and Wi-Fi
Open the Alt Text task pane and add the following description as alt text. - correct answer-
Right click the picture > Select "edit alt text" > In the alt text task pane, type.
Change the Junk E-mail options to only accept emails from people you deem as safe. - correct answer-
Home > Junk > Junk email options > Safe Lists Only
Create a email signature for new emails - correct answer-
Incorrect: File > Outlook Options > Mail > Create or modify signatures > Create new signature. Select
for new messages in the dialog box on the right. Save. Click OK.
Import data from the 'NewAccountsPayable' tab-
delimited text file and append the records to the 'AccountsPayable' table. The first row in the text file i
s the header row. Save the import steps. Use the default name by Access. - correct answer-
External Data tab > Import & Link group > 'New Data Source' > 'From File' > 'Text File'.
, Click 'Browse...'. Click 'NewAccountsPayable' and 'Open'.
Click the 'Append a copy of the records to the table:' radio button, and verify that 'AccountsPayable' is
selected. Click 'OK'. Click 'Next'. 'De-limited' radio button is selected.
Select 'First Row Contains Field Names' check box. Click 'Next'. Click 'Finish'. Select 'Save Import Ste
ps' check box. Click the 'Save Import' button.
Paste the copied cells so the formulas, formatting and source cell widths are pasted. - correct answer-
Incorrect: Home > Paste menu > Paste Special
Preview how this worksheet would print with formulas showing instead of calculated values. -
correct answer-Formulas> Formula Auditing > Show Formulas button. Click the File tab. Click Print.
Preview how this worksheet would print with formulas showing instead of calculated values. -
correct answer-
on the formulas tab in the formula auditing group, click the show formulas button. click the file tab. cli
ck print
A supercomputer is a machine that can fill a warehouse-
sized room. Select your answer, then click Done. - correct answer-tru
Apply the Colored Fill -
Accent 6, Dark 1 Outline graphics style to the icon. It is the last option in the third row of the gallery.
- correct answer-
? In the Insert Ribbon Tab in the Illustrations Ribbon Group, you clicked the SmartArt button. Inside t
he Choose a SmartArt Graphic dialog from the SmartArt Category list, you selected Process. Inside the
Choose a SmartArt Graphic dialog, you clicked the Step Up Process image, clicked the OK button.
Insert the current date and time in cell A1. - correct answer-
In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Date & Time butt
on. In the Date & Time menu, you clicked the NOW menu item. Inside the Function Arguments dialog
, you clicked the OK button
Complete the one-
variable data table in cells E3:F8 to calculate the breakeven sales point for varying owner withdrawal a
Questions And Answers With Solutions 2026
Check for new updates to Office - correct answer-Incorrect: File > Account > Whats New
In cell D15, enter a formula using a counting function to count the number of cells in the "Billable ?"
column (cells D2:D14) that are not blank. - correct answer-
Formulas tab > Function Library, click More Functions, point to statistical and select COUNTA from t
he list. Click and drag to select cells D2:D14. Click OK.
Insert an index based on the Classic format. The entries should display in two columns. -
correct answer-
Click the references tab. In the index group, click the insert index button. Click the formats drop down
arrow and select Classic. Click OK.
A company creates a by using a wireless access point (WAP) and an Internet connection. Select
the two correct answers, then click Done. - correct answer-Wireless LAN and Wi-Fi
Open the Alt Text task pane and add the following description as alt text. - correct answer-
Right click the picture > Select "edit alt text" > In the alt text task pane, type.
Change the Junk E-mail options to only accept emails from people you deem as safe. - correct answer-
Home > Junk > Junk email options > Safe Lists Only
Create a email signature for new emails - correct answer-
Incorrect: File > Outlook Options > Mail > Create or modify signatures > Create new signature. Select
for new messages in the dialog box on the right. Save. Click OK.
Import data from the 'NewAccountsPayable' tab-
delimited text file and append the records to the 'AccountsPayable' table. The first row in the text file i
s the header row. Save the import steps. Use the default name by Access. - correct answer-
External Data tab > Import & Link group > 'New Data Source' > 'From File' > 'Text File'.
, Click 'Browse...'. Click 'NewAccountsPayable' and 'Open'.
Click the 'Append a copy of the records to the table:' radio button, and verify that 'AccountsPayable' is
selected. Click 'OK'. Click 'Next'. 'De-limited' radio button is selected.
Select 'First Row Contains Field Names' check box. Click 'Next'. Click 'Finish'. Select 'Save Import Ste
ps' check box. Click the 'Save Import' button.
Paste the copied cells so the formulas, formatting and source cell widths are pasted. - correct answer-
Incorrect: Home > Paste menu > Paste Special
Preview how this worksheet would print with formulas showing instead of calculated values. -
correct answer-Formulas> Formula Auditing > Show Formulas button. Click the File tab. Click Print.
Preview how this worksheet would print with formulas showing instead of calculated values. -
correct answer-
on the formulas tab in the formula auditing group, click the show formulas button. click the file tab. cli
ck print
A supercomputer is a machine that can fill a warehouse-
sized room. Select your answer, then click Done. - correct answer-tru
Apply the Colored Fill -
Accent 6, Dark 1 Outline graphics style to the icon. It is the last option in the third row of the gallery.
- correct answer-
? In the Insert Ribbon Tab in the Illustrations Ribbon Group, you clicked the SmartArt button. Inside t
he Choose a SmartArt Graphic dialog from the SmartArt Category list, you selected Process. Inside the
Choose a SmartArt Graphic dialog, you clicked the Step Up Process image, clicked the OK button.
Insert the current date and time in cell A1. - correct answer-
In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Date & Time butt
on. In the Date & Time menu, you clicked the NOW menu item. Inside the Function Arguments dialog
, you clicked the OK button
Complete the one-
variable data table in cells E3:F8 to calculate the breakeven sales point for varying owner withdrawal a
