Microsoft Excel and Access - Practice
Final Exam Review with 100% correct
answers already graded A+
Mr. Johnson, the FBLA adviser, is updating the membership database
table for the new school year. He wants to define the fields to
display and simplify the interface by adding labels and instructions.
He would use a: - answer form
Which command on the Home Tab do you use to organize data in
ascending or descending order? - answer Sort & Filter
John wants to print only the Inventory worksheet that he is
currently working on in his workbook. Which option should he
choose? - answer Print Active Sheet
Ashton needs to add a footer to the data entry form in his gaming
database. Which view will allow Ashton to add a footer? - answer
Design View
David wants to key the numbers 1 to 1,000 in Column A of his
spreadsheet. What command should he use to complete this task? -
answer AutoFill
Erin needs to prepare a custom table for her recipe collection. She
has to include the ingredient portions. Which is the correct tool to
use? - answer Design view
Kirtan has worked for years cataloging his music collection into a
database. During a recent storm, Kirtan's computer was damaged,
but fortunately he has a backup on his flash drive. Which method
should he use to restore his database on his new computer? -
answer Recover from Backup
, Terry's form needs to display the FBLA member's exact age based on
today's date and their birth date. Which type of control would allow
Terry to display information that would change every day? - answer
Calculated
Joan has a table that includes demographic information about her
employees. What does all the information about one employee
represent? - answer Row
Joe wants to modify the query he created to incorporate various
colors, fonts and styles to create a custom look. Which query would
he use? - answer Query Design View
Which command on the Page Layout Tab enables a user to flip
objects on a worksheet? - answer Rotate
Which tab displays report printing options? - answer Report Design
Tools > Page Setup Tab
Marci is searching a Planet Database. She wants to find out how
many moons Saturn has and the names. Which comparison operator
would she use? - answer and
Wendy needs to print to the color printer instead of the default
printer on her computer. Which option would give her the choice to
change the printer? - answer Print
Carol has created a table from her database to see all information
about FBLA chapters in her region. She needs to know which
chapter has the most active members in the region. Which
aggregate function should she use? - answer Max
Final Exam Review with 100% correct
answers already graded A+
Mr. Johnson, the FBLA adviser, is updating the membership database
table for the new school year. He wants to define the fields to
display and simplify the interface by adding labels and instructions.
He would use a: - answer form
Which command on the Home Tab do you use to organize data in
ascending or descending order? - answer Sort & Filter
John wants to print only the Inventory worksheet that he is
currently working on in his workbook. Which option should he
choose? - answer Print Active Sheet
Ashton needs to add a footer to the data entry form in his gaming
database. Which view will allow Ashton to add a footer? - answer
Design View
David wants to key the numbers 1 to 1,000 in Column A of his
spreadsheet. What command should he use to complete this task? -
answer AutoFill
Erin needs to prepare a custom table for her recipe collection. She
has to include the ingredient portions. Which is the correct tool to
use? - answer Design view
Kirtan has worked for years cataloging his music collection into a
database. During a recent storm, Kirtan's computer was damaged,
but fortunately he has a backup on his flash drive. Which method
should he use to restore his database on his new computer? -
answer Recover from Backup
, Terry's form needs to display the FBLA member's exact age based on
today's date and their birth date. Which type of control would allow
Terry to display information that would change every day? - answer
Calculated
Joan has a table that includes demographic information about her
employees. What does all the information about one employee
represent? - answer Row
Joe wants to modify the query he created to incorporate various
colors, fonts and styles to create a custom look. Which query would
he use? - answer Query Design View
Which command on the Page Layout Tab enables a user to flip
objects on a worksheet? - answer Rotate
Which tab displays report printing options? - answer Report Design
Tools > Page Setup Tab
Marci is searching a Planet Database. She wants to find out how
many moons Saturn has and the names. Which comparison operator
would she use? - answer and
Wendy needs to print to the color printer instead of the default
printer on her computer. Which option would give her the choice to
change the printer? - answer Print
Carol has created a table from her database to see all information
about FBLA chapters in her region. She needs to know which
chapter has the most active members in the region. Which
aggregate function should she use? - answer Max
