Question

1. Write the Shortcut keys for the following:
a) To save a workbook
b) To create a new worksheet
c) To select the active row
d) To select all cells of a worksheet
2. A table from the computer course DBA is given below. Answer the following questions
based on the table:
Tutorial_Id Title Category
1001 Access Tutorial Software
1002 Excel Tutorial Software
1003 Database Design Tutorial Software
1004 Oracle DBA Course Software
1005 Raid Storage Tutorial Hardware
1006 Network Security Tutorial Networks
a) What is the total number of records in the table?
b) What is the total number of fields in the table?
c) What is the title of the record with category ‘Networks'?
d) Which category has the maximum number of records?
3. Write the steps to create a presentation by using template in Libre Office Calc.

Answer 1

Explanation:

1. a) CRL+S

b)CRL+N

c)CRL+Z

d)CRL+A

Answer 2

Answer:

Ctrl+N: Create a new workbook.

Ctrl+O: Open an existing workbook.

Ctrl+S: Save a workbook.

F12: Open the Save As dialog box.

Ctrl+W: Close a workbook.

Ctrl+F4: Close Excel.

F4: Repeat the last command or action. ...

Shift+F11: Insert a new worksheet.