Mastering Excel, Word, Canva, and Appsheet

What is the formula to sum a range of cells in Excel?

• =SUMMATION(range)

• =SUM(range)

• =ADD(range)

• =TOTAL(range)

How do you change the font size in a Word document?

• Use the 'Insert' tab to adjust the font size settings.

• Select the text, go to the 'Home' tab, and adjust the font size in the 'Font' group.

• Change the font size by right-clicking the text and selecting 'Font Size'.

• Font size can only be changed in the 'View' tab of Word.

What is the purpose of white space in Canva designs?

• The purpose of white space in Canva designs is to improve readability and create a balanced layout.

• To fill empty spaces with images.

• To distract the viewer from the main content.

• To add more colors to the design.

How can you add a new data source in Appsheet?

• Click on 'Settings' and choose 'Add New Source'.

• Open 'Reports' and select 'Import Data Source'.

• Go to the 'Data' tab, select 'Data Sources', and click 'Add Data Source'.

• Navigate to 'Home', then select 'New Data'.

Which function would you use to find the average of a set of numbers in Excel?

• COUNT

• SUM

• AVERAGE

• MAX

What is the shortcut for bolding text in Word?

• Ctrl + B

• Ctrl + U

• Ctrl + A

• Ctrl + I

What is a color palette and why is it important in Canva?

• A color palette is a tool for measuring color brightness.

• A color palette is a type of paint used in art.

• A color palette is a selection of colors used in design, important in Canva for maintaining brand consistency and enhancing visual appeal.

• A color palette is a collection of fonts used in design.

How do you create a new table in Appsheet?

• Go to Data > Tables > Add Table and select your data source.

• Select Data > New Table > Import Data.

• Go to Settings > Tables > Create New Table.

• Navigate to Tables > Add New > Choose Template.

What formula would you use to count the number of cells with numbers in Excel?

• =COUNT(range)

• =MAX(range)

• =SUM(range)

• =AVERAGE(range)

How can you insert a page break in a Word document?

• Press 'Alt + P' to add a page break.

• Insert a page break by clicking 'File' and selecting 'New Page'.

• Use the 'Home' tab and click on 'Insert Page'.

• Insert a page break by going to the 'Insert' tab and selecting 'Page Break' or by pressing 'Ctrl + Enter'.